UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Zb/ZnMnLVZvZHc+rG2yHSxswSIQEQDGBJgvxc70jU9g='
WHERE
key_id = '3a2d11db12d1bc8a7b8add0253d43529e2afa84f5992a7b6736b72d2fdabe94a'
AND (
token = 'Zb/ZnMnLVZvZHc+rG2yHSxswSIQEQDGBJgvxc70jU9g='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)