UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'G7lfcIsDlQWIbYhICZJWDFgSg3SaIwouo5sX612a6pc='
WHERE
key_id = '21634352d3590d8c963c83f1c945c6fb348f8ec05043a9689174792ce69e8b68'
AND (
token = 'G7lfcIsDlQWIbYhICZJWDFgSg3SaIwouo5sX612a6pc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)