UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'yfzfrdNqQdw1BhBWqOh5/aINecX6j5f6EFuwO4IMeBE='
WHERE
key_id = '9523942ebded2d7df402f3232647b185e152f05ec9f35fecdd21a47e3569fc7a'
AND (
token = 'yfzfrdNqQdw1BhBWqOh5/aINecX6j5f6EFuwO4IMeBE='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)