UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'SNWyTcjRBR1I1jnX0cywyppqVASYgzGAgK98aiNvYRQ='
WHERE
key_id = '8f1766e39fa4d8fc734de75274e52cc250d11432ad90738f3a2fae9b763125bc'
AND (
token = 'SNWyTcjRBR1I1jnX0cywyppqVASYgzGAgK98aiNvYRQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)