UPDATE 
  cscart_lock_keys 
SET 
  expiry_at = UNIX_TIMESTAMP(NOW()) + 30, 
  token = '+rYsKAXbjXGc7O9mD4skyHiBuInTarUOArDHTe0ZX4I=' 
WHERE 
  key_id = '3ae2024374f07bc62a6075e02c81112c3abe3b18d9a526a399d7cbed98de87e4' 
  AND (
    token = '+rYsKAXbjXGc7O9mD4skyHiBuInTarUOArDHTe0ZX4I=' 
    OR expiry_at <= UNIX_TIMESTAMP(NOW())
  )

Query time 0.00021