UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '0n7kvWcxNafm61Ebvuz6kg5RpMmFNY480I1NgTZPPYk='
WHERE
key_id = 'c7507022f4d90f5ea57685d8a88010ddc9f149b9b8891efef32b6232b19af39f'
AND (
token = '0n7kvWcxNafm61Ebvuz6kg5RpMmFNY480I1NgTZPPYk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)