UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'oICGANr9ON1KsKrn8hwAc+2200B8UIjm2etBJtfJwQg='
WHERE
key_id = 'a57b34f6bee24a48f2d4eb37f011357cadf2e935dfb1c17117c2e8b772282c4d'
AND (
token = 'oICGANr9ON1KsKrn8hwAc+2200B8UIjm2etBJtfJwQg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)