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