UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nsAh7Y56825xfhCCmW9jKdZj9zBtuzdjBS5dGLo76Sw='
WHERE
key_id = '7d4a67853c306be21e9250dff0674d85e5faf214261549f1cbba7e63995bc108'
AND (
token = 'nsAh7Y56825xfhCCmW9jKdZj9zBtuzdjBS5dGLo76Sw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)