UPDATE
cscart_aprillock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8sGurp8KrsiTXxk/fZcvaGwbTU7G9XZx5vsOWR27taI='
WHERE
key_id = 'cc554357348a79aa1e85b45c83d64db6d891c766c3adb68bbc6e28c64216ee20'
AND (
token = '8sGurp8KrsiTXxk/fZcvaGwbTU7G9XZx5vsOWR27taI='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)