UPDATE 
  cscart_aprillock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'X16v4NqD5wYaCOJ7t6VRYeVJ1+YJ4dTD2UaZ0IB5ajI=' 
WHERE 
  key_id = '8a2145356102d5c7c201de88d588b323d206fc13aadccd711fc605f4df9a0d58' 
  AND (
    token = 'X16v4NqD5wYaCOJ7t6VRYeVJ1+YJ4dTD2UaZ0IB5ajI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00034