UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'bCMKTYVocaJlS8horW5yK7WToHXRSEuSZI7dvNSuA3c='
WHERE
key_id = '00a795b7cef4dde9cc721b2fc4c7eafc7d2b1e9901efc0271030ac2ac06d5e69'
AND (
token = 'bCMKTYVocaJlS8horW5yK7WToHXRSEuSZI7dvNSuA3c='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)