UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6v4nvzQpjitMRwblMAtNWWyDWVKQ2qP+dsIlYM0JcmA='
WHERE
key_id = '94a23e7a31f9bf52a698cb83f118afd8975725d7d305818f20602f175df13ceb'
AND (
token = '6v4nvzQpjitMRwblMAtNWWyDWVKQ2qP+dsIlYM0JcmA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)