UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7mq3q66lExvsQpz4wD7mL4tCiejVDH8AsRcVS3UTC+0='
WHERE
key_id = '9415a4e8220df6a95d77e7659e75ba4417cfc0504007217dc63cb981184fef5b'
AND (
token = '7mq3q66lExvsQpz4wD7mL4tCiejVDH8AsRcVS3UTC+0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)