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