UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'xriDE7wtVUluu1SAsp4HPjCtkbVxMvh8U78MSHYTDno='
WHERE
key_id = 'f1d625f3d9ca0ac7f28c0e4850453d55a96619bfa85517f17bf4d7374ae57c1a'
AND (
token = 'xriDE7wtVUluu1SAsp4HPjCtkbVxMvh8U78MSHYTDno='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)