UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'tnHJMWHRqvvHNAqPpMLl16EHMFvv48o+/JjaBIs6OWc='
WHERE
key_id = '165ddfab58cabf74ab95b25dd874fe45a2393ce56b529af8d82033bf3a366b5f'
AND (
token = 'tnHJMWHRqvvHNAqPpMLl16EHMFvv48o+/JjaBIs6OWc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)