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