UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XdVQLHuh60y6T5HdD4lyPFs7m5ipplZIImb1qw0iisY='
WHERE
key_id = '96adb16a194eeac144b687b667a2753b30dfb381c2e0a3f84f8affc5d3f0a4b2'
AND (
token = 'XdVQLHuh60y6T5HdD4lyPFs7m5ipplZIImb1qw0iisY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)