UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'W0z9Jv8E8QHIx78wSq4M5u4XlGdOiB4QDCXNkttzmWg='
WHERE
key_id = '80e4177cf3879b767d8ecee2b0d9b93bf342c982efcca0d7ffd84e18386e9965'
AND (
token = 'W0z9Jv8E8QHIx78wSq4M5u4XlGdOiB4QDCXNkttzmWg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)