UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7ZhA+v4tzVRDn8P+cyUyW7madIcYJhaPvYE1yaHQNnk='
WHERE
key_id = '8efdf922207794d3b192570f45faadf11f2e97a0f394bce3e24d10eda6d69f83'
AND (
token = '7ZhA+v4tzVRDn8P+cyUyW7madIcYJhaPvYE1yaHQNnk='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)