UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = 'LE9cB5zJJqrRKhJR5JbtU3uvmnnvH04pL/77bp6i/cI=' 
WHERE 
  key_id = 'da2d7d01fbf9c7b03fe7ef434c68b8d3c3bbd5666f521fe7d785530c360fadad' 
  AND (
    token = 'LE9cB5zJJqrRKhJR5JbtU3uvmnnvH04pL/77bp6i/cI=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00023