UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6iIPdIpo3Fl344QfqU5qPKsupd75bePvSqcXdWyfge8='
WHERE
key_id = '3cececd98503b14143d63fe4b68ef0b8607ba98994a96f35f1b3967cb8c0e04a'
AND (
token = '6iIPdIpo3Fl344QfqU5qPKsupd75bePvSqcXdWyfge8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)