UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JLnJDWiJA9eczeZKeN3N8Z6lJwQqSs+aYt7XWQHWBcs='
WHERE
key_id = '78165cf0551fa91a664dde266ec3d29a32213de48b1b830a9db05e63636fd15f'
AND (
token = 'JLnJDWiJA9eczeZKeN3N8Z6lJwQqSs+aYt7XWQHWBcs='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)