UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'gdt12DG7LYVgJMzwvgsDZOlcPHuFC1m1tuVeRPYzwcI='
WHERE
key_id = '83c668272671dede2fdd500173bc3565ccdc6043967ac709b3e526a5ec2ee552'
AND (
token = 'gdt12DG7LYVgJMzwvgsDZOlcPHuFC1m1tuVeRPYzwcI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)