UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'USk5HcI65S4MhpQgSYwIvUB1X3ZQTBaU9m5ZjHpG+oY='
WHERE
key_id = 'af6b4a5e704e9a88a67c823afc85527d92636fda80e76f1d1dc920b9e387c4d1'
AND (
token = 'USk5HcI65S4MhpQgSYwIvUB1X3ZQTBaU9m5ZjHpG+oY='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)