UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r4JJITvrqFgSCseK2V6u9GQTWclC9UgMsys/kc8YwNI='
WHERE
key_id = 'c7e954e2d9227bf4fe7ae8f6193f35659a4b8766eb190094470f8d089b4eea3a'
AND (
token = 'r4JJITvrqFgSCseK2V6u9GQTWclC9UgMsys/kc8YwNI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)