UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'MY+dnBID/B1xGVoK1QItc98lbId0Ymp7HdXgFVP01l8='
WHERE
key_id = '1012a8df42abf0656880077e3d63eb95c945b807a1f0ea4dfa9a4ae62e762a76'
AND (
token = 'MY+dnBID/B1xGVoK1QItc98lbId0Ymp7HdXgFVP01l8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)