UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0yZCBxKJILfAZkDjTEnjUUWWdbpO14fpw9usLlCr/S8='
WHERE
key_id = '4ebf7494632f479d4319f6e4bb4fbf2963e197513f1d850351f544db8f4f99c8'
AND (
token = '0yZCBxKJILfAZkDjTEnjUUWWdbpO14fpw9usLlCr/S8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)