UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0Fi4zM1rOstOvDygDZhD7ljYEQ19awZvjbu09ooJwHY='
WHERE
key_id = '1f28bc7254c62e98497c08b023c898d1a4bfbe240e826f0a3b12e0d9899e2f86'
AND (
token = '0Fi4zM1rOstOvDygDZhD7ljYEQ19awZvjbu09ooJwHY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)