UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Lc/339y/jW9MrU6ji6znManZnuKBkslEim3KEuNxFE4='
WHERE
key_id = '586997ec7aafa2c35f096fa210f4b6d5e71dc94a0f5287af762ae1428e92c218'
AND (
token = 'Lc/339y/jW9MrU6ji6znManZnuKBkslEim3KEuNxFE4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)