UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'ZV5HDVpBgMVBm06qhf4HTp0OUI3xcDxhQOUZrc+X12w='
WHERE
key_id = '20c452f2c4d91ab9cb8ce5ae913f23a78c8ba8f0985b1d11603f96d0c1ac067f'
AND (
token = 'ZV5HDVpBgMVBm06qhf4HTp0OUI3xcDxhQOUZrc+X12w='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)