UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'upDrLh5DQKW46hwL9UGHDn/hqOSkTdPiAijxHM9lSNA='
WHERE
key_id = '53a9696a94ee35f20ddb522ea620e4f67d36092f5e96f9f5dc5ce3af30b3b41a'
AND (
token = 'upDrLh5DQKW46hwL9UGHDn/hqOSkTdPiAijxHM9lSNA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)