UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'C6wzW7pDCvLzwr+IPTk7dEX8YDUr9YbZJ0c5DfOH9a0='
WHERE
key_id = '1e593ea66b05332430633f4a5164190c9c6bf80953c1a8a2b8404d7638b366cf'
AND (
token = 'C6wzW7pDCvLzwr+IPTk7dEX8YDUr9YbZJ0c5DfOH9a0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)