UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'p5OrE3LRtkNFrN1SBoHY19acwxGGbmfp2zfP1atIY50='
WHERE
key_id = 'c162002f8a58c67fe36dbf9b640e0b305526583587fbc5e7b97a50ced6cfe170'
AND (
token = 'p5OrE3LRtkNFrN1SBoHY19acwxGGbmfp2zfP1atIY50='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)