UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ec5bGLsCq0hQwCmY8ZThQZFBJ7sikL9i3PpBAs17JcA='
WHERE
key_id = 'f4f45cebdcbc57e0103a52e0d70572ada5e9439fb5e650a1fb200c4407e43e90'
AND (
token = 'ec5bGLsCq0hQwCmY8ZThQZFBJ7sikL9i3PpBAs17JcA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)