UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jA88jAKZKPWNjmyb44ZNGr0xiyCKjLOgXG8afDynuek='
WHERE
key_id = '9cdc7fce8a708b334a8052b493f0085615a44dd5c268a4d28a9a4afe709913ac'
AND (
token = 'jA88jAKZKPWNjmyb44ZNGr0xiyCKjLOgXG8afDynuek='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)