UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p5dUsGr9MBlGSiIDGOnN59qdQAn1HqWzqWYQtJmXj04='
WHERE
key_id = '806681e03d8b0cc23aa55c82d926801fd338b18013339010a8efd4fd72182d50'
AND (
token = 'p5dUsGr9MBlGSiIDGOnN59qdQAn1HqWzqWYQtJmXj04='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)