UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '2fRSUkVg1aGG7V9SIiwF+LE6vIJqTAr6pP5oun6RVl8='
WHERE
key_id = '671ac18304fa0e3e185dbd34ac91bc4400b644bb0d06e41f0799fe8fb1d96f95'
AND (
token = '2fRSUkVg1aGG7V9SIiwF+LE6vIJqTAr6pP5oun6RVl8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)