UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 't19witf1CmaY3Fi79v7VyO0NIort/a9ooljye0gzKkg=' 
WHERE 
  key_id = 'fee7eaeb453368ee8f00dff71af35f38abd00e80a6242dc955170ea3d4f30fa1' 
  AND (
    token = 't19witf1CmaY3Fi79v7VyO0NIort/a9ooljye0gzKkg=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00032