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