UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'hU0+N1NtRdObVcGk+GtlQgdnHszyS4vqU30S5OQiIYc='
WHERE
key_id = '964e96941ce87b8735670b883449fc9c7f9ad5c811425f6f8dcb16ebf13cf2fe'
AND (
token = 'hU0+N1NtRdObVcGk+GtlQgdnHszyS4vqU30S5OQiIYc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)