UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'q0iWrN4HdyRlcOzkf5zgYeSfZavY6FDct+XgpYwMFZI='
WHERE
key_id = 'add9d34c60008eb8b6d25c717f562933293a92a63110d4923c5f27c1ac9683ca'
AND (
token = 'q0iWrN4HdyRlcOzkf5zgYeSfZavY6FDct+XgpYwMFZI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)