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